sqoop import \
--connect jdbc:mysql://106.75.33.59:3306/teach \
--username itcast_edu_stu \
--password itcast_edu_stu \
--table class_studying_student_count \
--fields-terminated-by '\t' \
--hcatalog-database edu_online_ods \
--hcatalog-table class_studying_student_count \
-m 1

sqoop import \
--connect 'jdbc:mysql://106.75.33.59:3306/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true'  \
--username itcast_edu_stu \
--password itcast_edu_stu \
--table course_table_upload_detail \
--fields-terminated-by '\t' \
--hcatalog-database edu_online_ods \
--hcatalog-table course_table_upload_detail \
-m 1

sqoop import \
--connect 'jdbc:mysql://106.75.33.59:3306/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query 'select * from tbh_student_signin_record where 1=1 and  \$CONDITIONS' \
--fields-terminated-by '\t' \
--hcatalog-database edu_online_ods \
--hcatalog-table tbh_student_signin_record \
-m 1

sqoop import \
--connect 'jdbc:mysql://106.75.33.59:3306/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query 'select * from tbh_class_time_table where 1=1 and  \$CONDITIONS' \
--fields-terminated-by '\t' \
--hcatalog-database edu_online_ods \
--hcatalog-table tbh_class_time_table \
-m 1

sqoop import \
--connect 'jdbc:mysql://106.75.33.59:3306/teach?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username itcast_edu_stu \
--password itcast_edu_stu \
--query 'select * from student_leave_apply where 1=1 and  \$CONDITIONS' \
--fields-terminated-by '\t' \
--hcatalog-database edu_online_ods \
--hcatalog-table student_leave_apply \
-m 1
